﻿<%@ Page Language="vb" AutoEventWireup="false" MasterPageFile="../CM/MainMaster.Master"
    CodeBehind="KR0010P01.aspx.vb" Inherits="Tohto.KR0010P01" %>

<%@ Register Assembly="FarPoint.Web.SpreadJ" Namespace="FarPoint.Web.Spread" TagPrefix="FarPoint" %>
<%@ Register Assembly="Tohto.Base.CustomControl" Namespace="Tohto.Base.CustomControl"
    TagPrefix="cc" %>
<%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="ajaxToolkit" %>
<asp:Content ID="Content1" ContentPlaceHolderID="MainContent" runat="server">
    <script type="text/javascript">

        function DoReady() {
            $("#<%=txt_article_cd.ClientId %>").attr("readonly", "true");
            $("#<%=txt_room_cd.ClientId %>").attr("readonly", "true");
            $("#<%=txt_room_nm.ClientId %>").attr("readonly", "true");    
        }

        function DataCheck() {
            ClearErrorBg();

            var yotei_from_date = $("#<%=txt_yotei_from_dt.ClientId%>");
            var yotei_to_date = $("#<%=txt_yotei_to_dt.ClientId%>");
            var kaishu_from_dt = $("#<%=txt_kaishu_from_dt.ClientId%>");
            var kaishu_to_dt = $("#<%=txt_kaishu_to_dt.ClientId%>");
            var koji_cd = $("#<%=txt_koji_cd.ClientId%>");

            if (!checkNull(yotei_from_date.val())) {
                if (!validateDate(yotei_from_date.val())) {
                    //日付の検証を行います。
                    SetErrorArea("CME0059", '回収予定日', 'yyyy/mm/dd', '', '');
                    yotei_from_date.focus();
                    yotei_from_date.addClass("errorRed");
                    return false;
                }
            }

            if (!checkNull(yotei_to_date.val())) {
                if (!validateDate(yotei_to_date.val())) {
                    //日付の検証を行います。
                    SetErrorArea("CME0059", '回収予定日', 'yyyy/mm/dd', '', '');
                    yotei_to_date.focus();
                    yotei_to_date.addClass("errorRed");
                    return false;
                }
            }

            if (!checkNull(kaishu_from_dt.val())) {
                if (!validateDate(kaishu_from_dt.val())) {
                    //日付の検証を行います。
                    SetErrorArea("CME0059", '回収日', 'yyyy/mm/dd', '', '');
                    kaishu_from_dt.focus();
                    kaishu_from_dt.addClass("errorRed");
                    return false;
                }
            }

            if (!checkNull(kaishu_to_dt.val())) {
                if (!validateDate(kaishu_to_dt.val())) {
                    //日付の検証を行います。
                    SetErrorArea("CME0059", '回収日', 'yyyy/mm/dd', '', '');
                    kaishu_to_dt.focus();
                    kaishu_to_dt.addClass("errorRed");
                    return false;
                }
            }

            if (!checkNull(koji_cd.val())) {
                if (!isNum(koji_cd.val())) {
                    SetErrorArea("CME0059", '工事NO.', '数字', '', '');
                    koji_cd.focus();
                    koji_cd.addClass("errorRed");
                    return false;
                }
            }
            return true;
        }

        function ClickDoubleRow() {
            var spread = document.getElementById("<%=spd_kaishu_yotei.ClientId%>");
            var row = spread.ActiveRow;
            if (row % 2 == 0) {
                spread.AddSelection(row, 0, 2, 16);
            }
            else {
                spread.AddSelection(row - 1, 0, 2, 16);
            }
        }


        /* 担当者参照 */
        function TantoSansyo() {
            var returnValue = ShowMDialog("../UT/UT0060P01.aspx", dialog_tantosya);

            if (returnValue != null) {
                $("#<%=txt_tanto_nm.ClientId %>").val(returnValue.name);
                $("#<%=lbl_tanto_cd.ClientId %>").val(returnValue.code);
                return false;
            } else {
                return false;
            }

        }

        /* 担当者をクリア */
        function TantoClear() {
            $("#<%=txt_tanto_nm.ClientId %>").val("");
            return false;
        }

        /*物件名データ取得*/
        function ArticleSansyo() {
            var returnValue = ShowMDialog("../UT/UT0010P01.aspx", dialog_tantosya);

            var article_cd = $("#<%=txt_article_cd.ClientId%>");
            var article_nm = $("#<%=txt_article_nm.ClientId%>");

            if (returnValue != null) {
                $("#<%=txt_article_cd.ClientId %>").val(returnValue.code);
                $("#<%=txt_article_nm.ClientId %>").val(returnValue.name);
                return false;
            } else {
                return false;
            }
        }

        /* 物件名をクリア */
        function ArticleClear() {
            $("#<%=txt_article_nm.ClientId %>").val("");
            $("#<%=txt_article_cd.ClientId %>").val("");
            return false;
        }


        /*部屋名データ取得*/
        function RoomSansyo() {
            var returnValue = ShowMDialog("../UT/UT0020P01.aspx", dialog_tantosya);
           
            if (returnValue != null) {
                $("#<%=txt_room_cd.ClientId %>").val(returnValue.code);
                $("#<%=txt_room_nm.ClientId %>").val(returnValue.name);
                return false;
            } else {
                return false;
            }
        }

        /* 部屋名をクリア */
        function RoomClear() {
            $("#<%=txt_room_nm.ClientId %>").val("");
            $("#<%=txt_room_cd.ClientId %>").val("");
            return false;
        }

        /*工事No.データ取得*/
        function getkoji() {
            var returnValue = ShowMDialog("KJ0020P05.aspx");
            if (returnValue != null) {
                return true;
            } else {
                return false;
            }
        }

        /* 画面クリア */
        function pageClear() {
            if (ShowMsgDialog("CMQ0005", '', '', '', '') == true) {
                return true;
            } else {
                return false;
            }

        }
    </script>
    <div id="main_div" class="kr0010p01_div_main">
        <div id="search_title">
            <span class="sub_title_marck">◆</span><span class="sub_title">検索</span>
        </div>
        <div id="search_main">
            <table>
                <tr>
                    <td class="label_background border_top">
                        部署
                    </td>
                    <td colspan="6" class="border_top white_td">
                        <cc:ReadOnlyDropDownList ID="cmb_post" CssClass="kr0010p01_cmb_post" runat="server"
                            TabIndex="1" ReadOnlyWidth="-2">
                            <asp:ListItem Value="0">ＮＮＮＮＮＮＮＮＮ２０ＮＮＮＮＮＮＮＮＮ</asp:ListItem>
                            <asp:ListItem Value="1">ＮＮＮＮＮＮＮＮＮ２０ＮＮＮＮＮＮＮＮＮ</asp:ListItem>
                            <asp:ListItem Value="2">ＮＮＮＮＮＮＮＮＮ２０ＮＮＮＮＮＮＮＮＮ</asp:ListItem>
                            <asp:ListItem Value="3">ＮＮＮＮＮＮＮＮＮ２０ＮＮＮＮＮＮＮＮＮ</asp:ListItem>
                            <asp:ListItem Value="4">ＮＮＮＮＮＮＮＮＮ２０ＮＮＮＮＮＮＮＮＮ</asp:ListItem>
                        </cc:ReadOnlyDropDownList>
                    </td>
                    <td class="label_background border_top">
                        担当者
                    </td>
                    <td class="border_top white_td">
                        <asp:TextBox ID="txt_tanto_nm" runat="server" MaxLength="20" TabIndex="2" CssClass="kr0010p01_tanto"
                            Text="ＮＮＮＮ１０ＮＮＮＮ" />
                    </td>
                    <td class="border_top">
                        <asp:Button ID="btn_tanto_search" CssClass="select_button" runat="server" TabIndex="3"
                            OnClientClick="return TantoSansyo();" />
                    </td>
                    <td class="border_right border_top">
                        <asp:Button ID="btn_tanto_clear" CssClass="clear_button" Text="C" runat="server"
                            TabIndex="4" OnClientClick="return TantoClear();" />
                    </td>
                </tr>
                <tr>
                    <td class="label_background">
                        回収方法
                    </td>
                    <td colspan="2" class="white_td">
                        <cc:ReadOnlyDropDownList ID="cmb_way_of_recycle" CssClass="kr0010p01_cmb_recycle"
                            runat="server" TabIndex="6" ReadOnlyWidth="-2">
                            <asp:ListItem Value="0">ＮＮＮＮＮ</asp:ListItem>
                            <asp:ListItem Value="1">ＮＮＮＮＮ</asp:ListItem>
                            <asp:ListItem Value="2">ＮＮＮＮＮ</asp:ListItem>
                            <asp:ListItem Value="3">ＮＮＮＮＮ</asp:ListItem>
                            <asp:ListItem Value="4">ＮＮＮＮＮ</asp:ListItem>
                        </cc:ReadOnlyDropDownList>
                    </td>
                    <td class="noborder_bottom">
                    </td>
                    <td class="noborder_left">
                    </td>
                    <td class="noborder_left">
                    </td>
                    <td class="noborder_bottom noborder_left">
                    </td>
                    <td class="noborder_bottom noborder_left">
                    </td>
                    <td class="noborder_bottom noborder_left">
                        <asp:Label ID="lbl_tanto_cd" runat="server" Visible="false" />
                    </td>
                    <td class="noborder_bottom noborder_left">
                    </td>
                    <td class="noborder_bottom noborder_left">
                    </td>
                </tr>
                <tr>
                    <td class="kr0010p01_lbl label_background">
                        回収予定日
                    </td>
                    <td class="kr0010p01_width_70 white_td">
                        <asp:TextBox ID="txt_yotei_from_dt" runat="server" MaxLength="10" TabIndex="8" Text="9999/99/99"
                            CssClass="kr0010p01_dt ime_disabled" />
                        <ajaxToolkit:CalendarExtender ID="yotei_from_dt" CssClass="MyCalendar" runat="server"
                            DaysModeTitleFormat="yyyy/MM/dd" Enabled="True" Format="yyyy/MM/dd" PopupButtonID="btn_yt_from_Calendar"
                            TargetControlID="txt_yotei_from_dt" TodaysDateFormat="yyyy/MM/dd">
                        </ajaxToolkit:CalendarExtender>
                    </td>
                    <td>
                        <asp:Button ID="btn_yt_from_Calendar" CssClass="calendar_button" runat="server" TabIndex="10" />
                    </td>
                    <td class="kr0010p01_wavedash">
                        ～
                    </td>
                    <td class="kr0010p01_width_70 white_td">
                        <asp:TextBox ID="txt_yotei_to_dt" runat="server" MaxLength="10" TabIndex="12" Text="9999/99/99"
                            CssClass="kr0010p01_dt ime_disabled" />
                        <ajaxToolkit:CalendarExtender ID="yotei_to_dt" CssClass="MyCalendar" runat="server"
                            DaysModeTitleFormat="yyyy/MM/dd" Enabled="True" Format="yyyy/MM/dd" PopupButtonID="btn_yt_to_Calendar"
                            TargetControlID="txt_yotei_to_dt" TodaysDateFormat="yyyy/MM/dd">
                        </ajaxToolkit:CalendarExtender>
                    </td>
                    <td>
                        <asp:Button ID="btn_yt_to_Calendar" CssClass="calendar_button" runat="server" TabIndex="14" />
                    </td>
                    <td class="noborder_bottom kr0010p01_width_80">
                    </td>
                    <td class="kr0010p01_lbl noborder_bottom noborder_left">
                    </td>
                    <td class="noborder_bottom noborder_left kr0010p01_width_143">
                    </td>
                    <td class="noborder_bottom noborder_left kr0010p01_width_18">
                    </td>
                    <td class="noborder_bottom noborder_left kr0010p01_width_18">
                    </td>
                </tr>
                <tr>
                    <td class="label_background">
                        回収日
                    </td>
                    <td class="white_td">
                        <asp:TextBox ID="txt_kaishu_from_dt" runat="server" MaxLength="10" TabIndex="16"
                            Text="9999/99/99" CssClass="kr0010p01_dt ime_disabled" />
                        <ajaxToolkit:CalendarExtender ID="kaishu_from_dt" CssClass="MyCalendar" runat="server"
                            DaysModeTitleFormat="yyyy/MM/dd" Enabled="True" Format="yyyy/MM/dd" PopupButtonID="btn_kaishu_from_calendar"
                            TargetControlID="txt_kaishu_from_dt" TodaysDateFormat="yyyy/MM/dd">
                        </ajaxToolkit:CalendarExtender>
                    </td>
                    <td>
                        <asp:Button ID="btn_kaishu_from_calendar" CssClass="calendar_button" runat="server"
                            TabIndex="18" />
                    </td>
                    <td class="kr0010p01_wavedash">
                        ～
                    </td>
                    <td class="white_td">
                        <asp:TextBox ID="txt_kaishu_to_dt" runat="server" MaxLength="10" TabIndex="20" Text="9999/99/99"
                            CssClass="kr0010p01_dt ime_disabled" />
                        <ajaxToolkit:CalendarExtender ID="kaishu_to_dt" CssClass="MyCalendar" runat="server"
                            DaysModeTitleFormat="yyyy/MM/dd" Enabled="True" Format="yyyy/MM/dd" PopupButtonID="btn_kaishu_to_calendar"
                            TargetControlID="txt_kaishu_to_dt" TodaysDateFormat="yyyy/MM/dd">
                        </ajaxToolkit:CalendarExtender>
                    </td>
                    <td>
                        <asp:Button ID="btn_kaishu_to_calendar" CssClass="calendar_button" runat="server"
                            TabIndex="22" />
                    </td>
                    <td class="noborder_bottom">
                    </td>
                    <td class="noborder_bottom noborder_left">
                    </td>
                    <td class="noborder_bottom noborder_left">
                    </td>
                    <td class="noborder_bottom noborder_left">
                    </td>
                    <td class="noborder_bottom noborder_left">
                    </td>
                </tr>
            </table>
        </div>
        <div class="kr0010p01_div_dis">
            <table>
                <tr>
                    <td class="kr0010p01_lbl label_background border_top">
                        物件名
                    </td>
                    <td class="border_top kr0010p01_width_70 white_td">
                        <asp:TextBox ID="txt_article_cd" runat="server" MaxLength="10" TabIndex="25" CssClass="kr0010p01_dt ime_disabled"
                            Text="999999999" />
                    </td>
                    <td class="border_top kr0010p01_width_350 white_td">
                        <asp:TextBox ID="txt_article_nm" runat="server" MaxLength="50" TabIndex="27" CssClass="kr0010p01_25_nm"
                            Text="ＮＮＮＮＮＮＮＮＮＮＮＮ２５ＮＮＮＮＮＮＮＮＮＮＮ" />
                    </td>
                    <td class="border_top">
                        <asp:Button ID="btn_article_search" CssClass="select_button" runat="server" TabIndex="30"
                            OnClientClick="return ArticleSansyo();" />
                    </td>
                    <td class="border_right border_top">
                        <asp:Button ID="btn_article_clear" CssClass="clear_button" Text="C" runat="server"
                            TabIndex="32" OnClientClick="return ArticleClear();" />
                    </td>
                </tr>
                <tr>
                    <td class="label_background">
                        部屋名
                    </td>
                    <td class="white_td">
                        <asp:TextBox ID="txt_room_cd" runat="server" MaxLength="10" TabIndex="34" CssClass="kr0010p01_dt ime_disabled"
                            Text="999999999" />
                    </td>
                    <td class="white_td">
                        <asp:TextBox ID="txt_room_nm" runat="server" MaxLength="50" TabIndex="36" CssClass="kr0010p01_25_nm"
                            Text="ＮＮＮＮＮＮＮＮＮＮＮＮ２５ＮＮＮＮＮＮＮＮＮＮＮ" />
                    </td>
                    <td class="border_top">
                        <asp:Button ID="btn_post_search" CssClass="select_button" runat="server" TabIndex="38"
                            OnClientClick="return RoomSansyo();" />
                    </td>
                    <td class="border_right border_top">
                        <asp:Button ID="btn_post_clear" CssClass="clear_button" Text="C" runat="server" TabIndex="40"
                            OnClientClick="return RoomClear();" />
                    </td>
                </tr>
                <tr>
                    <td class="label_background">
                        工事No.
                    </td>
                    <td class="white_td">
                        <asp:TextBox ID="txt_koji_cd" runat="server" MaxLength="10" TabIndex="42" CssClass="kr0010p01_dt ime_disabled"
                            Text="999999999" />
                    </td>
                    <td colspan="3" class="noborder_bottom">
                    </td>
                </tr>
            </table>
        </div>
        <div id="button_main" class="button_float_right">
            <div id="button_main_csv">
                <asp:Button ID="btn_csv" TabIndex="119" runat="server" Text="CSV" />
            </div>
            <div id="button_main_clear">
                <asp:Button ID="btn_clear" TabIndex="118" runat="server" Text="クリア" OnClientClick="return pageClear();" />
            </div>
            <div id="button_main_search">
                <asp:Button ID="btn_search" TabIndex="117" runat="server" Text="検索" OnClientClick="return DataCheck();" />
            </div>
        </div>
        <div class="kr0010p01_spd_dis">
            <FarPoint:FpSpread ID="spd_kaishu_yotei" runat="server" BorderColor="Black" BorderStyle="Solid"
                BorderWidth="1px" Height="200px" Width="768px" ActiveSheetViewIndex="0" currentPageIndex="0" ClientEvents-ActiveCellChanged="ClickDoubleRow"
                DesignString="&lt;?xml version=&quot;1.0&quot; encoding=&quot;utf-8&quot;?&gt;&lt;Spread /&gt;">
                <CommandBar BackColor="Control" ButtonFaceColor="Control" ButtonHighlightColor="ControlLightLight"
                    ButtonShadowColor="ControlDark" Visible="False">
                    <Background BackgroundImageUrl="SPREADCLIENTPATH:/img/cbbg.gif"></Background>
                </CommandBar>
                <Pager Font-Bold="False" Font-Italic="False" Font-Overline="False" Font-Strikeout="False"
                    Font-Underline="False" />
                <HierBar Font-Bold="False" Font-Italic="False" Font-Overline="False" Font-Strikeout="False"
                    Font-Underline="False" />
                <Sheets>
                    <FarPoint:SheetView SheetName="Sheet1" ColumnFooterVisible="True" DesignString="&lt;?xml version=&quot;1.0&quot; encoding=&quot;utf-8&quot;?&gt;&lt;Sheet&gt;&lt;Data&gt;&lt;RowHeader class=&quot;FarPoint.Web.Spread.Model.DefaultSheetDataModel&quot; rows=&quot;0&quot; columns=&quot;1&quot;&gt;&lt;AutoCalculation&gt;True&lt;/AutoCalculation&gt;&lt;AutoGenerateColumns&gt;True&lt;/AutoGenerateColumns&gt;&lt;ReferenceStyle&gt;A1&lt;/ReferenceStyle&gt;&lt;Iteration&gt;False&lt;/Iteration&gt;&lt;MaximumIterations&gt;1&lt;/MaximumIterations&gt;&lt;MaximumChange&gt;0.001&lt;/MaximumChange&gt;&lt;/RowHeader&gt;&lt;ColumnHeader class=&quot;FarPoint.Web.Spread.Model.DefaultSheetDataModel&quot; rows=&quot;2&quot; columns=&quot;12&quot;&gt;&lt;AutoCalculation&gt;True&lt;/AutoCalculation&gt;&lt;AutoGenerateColumns&gt;True&lt;/AutoGenerateColumns&gt;&lt;ReferenceStyle&gt;A1&lt;/ReferenceStyle&gt;&lt;Iteration&gt;False&lt;/Iteration&gt;&lt;MaximumIterations&gt;1&lt;/MaximumIterations&gt;&lt;MaximumChange&gt;0.001&lt;/MaximumChange&gt;&lt;Cells&gt;&lt;Cell row=&quot;0&quot; column=&quot;0&quot;&gt;&lt;Data type=&quot;System.String&quot;&gt;回収予定日&lt;/Data&gt;&lt;/Cell&gt;&lt;Cell row=&quot;0&quot; column=&quot;1&quot;&gt;&lt;Data type=&quot;System.String&quot;&gt;工事完了日&lt;/Data&gt;&lt;/Cell&gt;&lt;Cell row=&quot;0&quot; column=&quot;2&quot;&gt;&lt;Data type=&quot;System.String&quot;&gt;回収方法&lt;/Data&gt;&lt;/Cell&gt;&lt;Cell row=&quot;0&quot; column=&quot;3&quot;&gt;&lt;Data type=&quot;System.String&quot;&gt;顧客CD&lt;/Data&gt;&lt;/Cell&gt;&lt;Cell row=&quot;0&quot; column=&quot;4&quot;&gt;&lt;Data type=&quot;System.String&quot;&gt;工事No&lt;/Data&gt;&lt;/Cell&gt;&lt;Cell row=&quot;0&quot; column=&quot;5&quot;&gt;&lt;Data type=&quot;System.String&quot;&gt;物件&lt;/Data&gt;&lt;/Cell&gt;&lt;Cell row=&quot;0&quot; column=&quot;7&quot;&gt;&lt;Data type=&quot;System.String&quot;&gt;回収予定金額&lt;/Data&gt;&lt;/Cell&gt;&lt;Cell row=&quot;0&quot; column=&quot;8&quot;&gt;&lt;Data type=&quot;System.String&quot;&gt;回収金額&lt;/Data&gt;&lt;/Cell&gt;&lt;Cell row=&quot;0&quot; column=&quot;9&quot;&gt;&lt;Data type=&quot;System.String&quot;&gt;最終回収日&lt;/Data&gt;&lt;/Cell&gt;&lt;Cell row=&quot;0&quot; column=&quot;10&quot;&gt;&lt;Data type=&quot;System.String&quot;&gt;オーナー契約CD&lt;/Data&gt;&lt;/Cell&gt;&lt;Cell row=&quot;0&quot; column=&quot;11&quot;&gt;&lt;Data type=&quot;System.String&quot;&gt;T2請求CD&lt;/Data&gt;&lt;/Cell&gt;&lt;Cell row=&quot;1&quot; column=&quot;0&quot;&gt;&lt;Data type=&quot;System.String&quot;&gt;回収予定日&lt;/Data&gt;&lt;/Cell&gt;&lt;Cell row=&quot;1&quot; column=&quot;1&quot;&gt;&lt;Data type=&quot;System.String&quot;&gt;工事完了日&lt;/Data&gt;&lt;/Cell&gt;&lt;Cell row=&quot;1&quot; column=&quot;3&quot;&gt;&lt;Data type=&quot;System.String&quot;&gt;顧客名&lt;/Data&gt;&lt;/Cell&gt;&lt;Cell row=&quot;1&quot; column=&quot;4&quot;&gt;&lt;Data type=&quot;System.String&quot;&gt;工事名&lt;/Data&gt;&lt;/Cell&gt;&lt;Cell row=&quot;1&quot; column=&quot;5&quot;&gt;&lt;Data type=&quot;System.String&quot;&gt;部屋&lt;/Data&gt;&lt;/Cell&gt;&lt;Cell row=&quot;1&quot; column=&quot;9&quot;&gt;&lt;Data type=&quot;System.String&quot;&gt;最終回収日&lt;/Data&gt;&lt;/Cell&gt;&lt;Cell row=&quot;1&quot; column=&quot;10&quot;&gt;&lt;Data type=&quot;System.String&quot;&gt;管理形態&lt;/Data&gt;&lt;/Cell&gt;&lt;/Cells&gt;&lt;/ColumnHeader&gt;&lt;DataArea class=&quot;FarPoint.Web.Spread.Model.DefaultSheetDataModel&quot; rows=&quot;0&quot; columns=&quot;12&quot;&gt;&lt;AutoCalculation&gt;True&lt;/AutoCalculation&gt;&lt;AutoGenerateColumns&gt;True&lt;/AutoGenerateColumns&gt;&lt;ReferenceStyle&gt;A1&lt;/ReferenceStyle&gt;&lt;Iteration&gt;False&lt;/Iteration&gt;&lt;MaximumIterations&gt;1&lt;/MaximumIterations&gt;&lt;MaximumChange&gt;0.001&lt;/MaximumChange&gt;&lt;SheetName&gt;Sheet1&lt;/SheetName&gt;&lt;/DataArea&gt;&lt;SheetCorner class=&quot;FarPoint.Web.Spread.Model.DefaultSheetDataModel&quot; rows=&quot;2&quot; columns=&quot;1&quot;&gt;&lt;AutoCalculation&gt;True&lt;/AutoCalculation&gt;&lt;AutoGenerateColumns&gt;True&lt;/AutoGenerateColumns&gt;&lt;ReferenceStyle&gt;A1&lt;/ReferenceStyle&gt;&lt;Iteration&gt;False&lt;/Iteration&gt;&lt;MaximumIterations&gt;1&lt;/MaximumIterations&gt;&lt;MaximumChange&gt;0.001&lt;/MaximumChange&gt;&lt;/SheetCorner&gt;&lt;ColumnFooter class=&quot;FarPoint.Web.Spread.Model.DefaultSheetDataModel&quot; rows=&quot;1&quot; columns=&quot;12&quot;&gt;&lt;AutoCalculation&gt;True&lt;/AutoCalculation&gt;&lt;AutoGenerateColumns&gt;True&lt;/AutoGenerateColumns&gt;&lt;ReferenceStyle&gt;A1&lt;/ReferenceStyle&gt;&lt;Iteration&gt;False&lt;/Iteration&gt;&lt;MaximumIterations&gt;1&lt;/MaximumIterations&gt;&lt;MaximumChange&gt;0.001&lt;/MaximumChange&gt;&lt;/ColumnFooter&gt;&lt;/Data&gt;&lt;Presentation&gt;&lt;AxisModels&gt;&lt;Column class=&quot;FarPoint.Web.Spread.Model.DefaultSheetAxisModel&quot; orientation=&quot;Horizontal&quot; count=&quot;12&quot;&gt;&lt;Items&gt;&lt;Item index=&quot;-1&quot;&gt;&lt;SortIndicator&gt;Ascending&lt;/SortIndicator&gt;&lt;/Item&gt;&lt;Item index=&quot;0&quot;&gt;&lt;Size&gt;88&lt;/Size&gt;&lt;/Item&gt;&lt;Item index=&quot;1&quot;&gt;&lt;Size&gt;90&lt;/Size&gt;&lt;/Item&gt;&lt;Item index=&quot;2&quot;&gt;&lt;Size&gt;78&lt;/Size&gt;&lt;/Item&gt;&lt;Item index=&quot;3&quot;&gt;&lt;Size&gt;115&lt;/Size&gt;&lt;/Item&gt;&lt;Item index=&quot;4&quot;&gt;&lt;Size&gt;108&lt;/Size&gt;&lt;/Item&gt;&lt;Item index=&quot;5&quot;&gt;&lt;Size&gt;93&lt;/Size&gt;&lt;/Item&gt;&lt;Item index=&quot;6&quot;&gt;&lt;Size&gt;166&lt;/Size&gt;&lt;/Item&gt;&lt;Item index=&quot;7&quot;&gt;&lt;Size&gt;106&lt;/Size&gt;&lt;/Item&gt;&lt;Item index=&quot;8&quot;&gt;&lt;Size&gt;106&lt;/Size&gt;&lt;/Item&gt;&lt;Item index=&quot;9&quot;&gt;&lt;Size&gt;93&lt;/Size&gt;&lt;/Item&gt;&lt;Item index=&quot;10&quot;&gt;&lt;Size&gt;110&lt;/Size&gt;&lt;/Item&gt;&lt;Item index=&quot;11&quot;&gt;&lt;Size&gt;104&lt;/Size&gt;&lt;/Item&gt;&lt;/Items&gt;&lt;/Column&gt;&lt;RowHeaderColumn class=&quot;FarPoint.Web.Spread.Model.DefaultSheetAxisModel&quot; defaultSize=&quot;20&quot; orientation=&quot;Horizontal&quot; count=&quot;1&quot;&gt;&lt;Items&gt;&lt;Item index=&quot;-1&quot;&gt;&lt;SortIndicator&gt;Ascending&lt;/SortIndicator&gt;&lt;Size&gt;20&lt;/Size&gt;&lt;/Item&gt;&lt;/Items&gt;&lt;/RowHeaderColumn&gt;&lt;ColumnHeaderRow class=&quot;FarPoint.Web.Spread.Model.DefaultSheetAxisModel&quot; defaultSize=&quot;22&quot; orientation=&quot;Vertical&quot; count=&quot;2&quot;&gt;&lt;Items&gt;&lt;Item index=&quot;-1&quot;&gt;&lt;Size&gt;22&lt;/Size&gt;&lt;/Item&gt;&lt;/Items&gt;&lt;/ColumnHeaderRow&gt;&lt;ColumnFooterRow class=&quot;FarPoint.Web.Spread.Model.DefaultSheetAxisModel&quot; defaultSize=&quot;22&quot; orientation=&quot;Vertical&quot; count=&quot;1&quot;&gt;&lt;Items&gt;&lt;Item index=&quot;-1&quot;&gt;&lt;Size&gt;22&lt;/Size&gt;&lt;/Item&gt;&lt;/Items&gt;&lt;/ColumnFooterRow&gt;&lt;/AxisModels&gt;&lt;SpanModels&gt;&lt;ColumnHeader class=&quot;FarPoint.Web.Spread.Model.DefaultSheetSpanModel&quot;&gt;&lt;CellRange Row=&quot;0&quot; Column=&quot;0&quot; RowCount=&quot;2&quot; ColumnCount=&quot;1&quot; /&gt;&lt;CellRange Row=&quot;0&quot; Column=&quot;1&quot; RowCount=&quot;2&quot; ColumnCount=&quot;1&quot; /&gt;&lt;CellRange Row=&quot;0&quot; Column=&quot;2&quot; RowCount=&quot;2&quot; ColumnCount=&quot;1&quot; /&gt;&lt;CellRange Row=&quot;0&quot; Column=&quot;7&quot; RowCount=&quot;2&quot; ColumnCount=&quot;1&quot; /&gt;&lt;CellRange Row=&quot;0&quot; Column=&quot;8&quot; RowCount=&quot;2&quot; ColumnCount=&quot;1&quot; /&gt;&lt;CellRange Row=&quot;0&quot; Column=&quot;11&quot; RowCount=&quot;2&quot; ColumnCount=&quot;1&quot; /&gt;&lt;CellRange Row=&quot;0&quot; Column=&quot;9&quot; RowCount=&quot;2&quot; ColumnCount=&quot;1&quot; /&gt;&lt;CellRange Row=&quot;0&quot; Column=&quot;5&quot; RowCount=&quot;1&quot; ColumnCount=&quot;2&quot; /&gt;&lt;CellRange Row=&quot;1&quot; Column=&quot;5&quot; RowCount=&quot;1&quot; ColumnCount=&quot;2&quot; /&gt;&lt;/ColumnHeader&gt;&lt;/SpanModels&gt;&lt;StyleModels&gt;&lt;RowHeader class=&quot;FarPoint.Web.Spread.Model.DefaultSheetStyleModel&quot; Rows=&quot;0&quot; Columns=&quot;1&quot;&gt;&lt;AltRowCount&gt;2&lt;/AltRowCount&gt;&lt;DefaultStyle class=&quot;FarPoint.Web.Spread.NamedStyle&quot; Parent=&quot;RowHeaderDefault&quot; /&gt;&lt;ConditionalFormatCollections /&gt;&lt;/RowHeader&gt;&lt;ColumnHeader class=&quot;FarPoint.Web.Spread.Model.DefaultSheetStyleModel&quot; Rows=&quot;2&quot; Columns=&quot;12&quot;&gt;&lt;AltRowCount&gt;2&lt;/AltRowCount&gt;&lt;DefaultStyle class=&quot;FarPoint.Web.Spread.NamedStyle&quot; Parent=&quot;ColumnHeaderDefault&quot;&gt;&lt;Background class=&quot;FarPoint.Web.Spread.Background&quot;&gt;&lt;BackgroundImageUrl&gt;SPREADCLIENTPATH:/img/chbg.gif&lt;/BackgroundImageUrl&gt;&lt;SelectedBackgroundImageUrl&gt;SPREADCLIENTPATH:/img/chm.png&lt;/SelectedBackgroundImageUrl&gt;&lt;/Background&gt;&lt;/DefaultStyle&gt;&lt;ColumnStyles&gt;&lt;ColumnStyle Index=&quot;0&quot;&gt;&lt;VerticalAlign&gt;Middle&lt;/VerticalAlign&gt;&lt;/ColumnStyle&gt;&lt;ColumnStyle Index=&quot;1&quot;&gt;&lt;VerticalAlign&gt;Middle&lt;/VerticalAlign&gt;&lt;/ColumnStyle&gt;&lt;ColumnStyle Index=&quot;2&quot;&gt;&lt;VerticalAlign&gt;Middle&lt;/VerticalAlign&gt;&lt;/ColumnStyle&gt;&lt;ColumnStyle Index=&quot;3&quot;&gt;&lt;VerticalAlign&gt;Middle&lt;/VerticalAlign&gt;&lt;/ColumnStyle&gt;&lt;ColumnStyle Index=&quot;4&quot;&gt;&lt;VerticalAlign&gt;Middle&lt;/VerticalAlign&gt;&lt;/ColumnStyle&gt;&lt;ColumnStyle Index=&quot;5&quot;&gt;&lt;VerticalAlign&gt;Middle&lt;/VerticalAlign&gt;&lt;/ColumnStyle&gt;&lt;ColumnStyle Index=&quot;6&quot;&gt;&lt;VerticalAlign&gt;Middle&lt;/VerticalAlign&gt;&lt;/ColumnStyle&gt;&lt;ColumnStyle Index=&quot;7&quot;&gt;&lt;VerticalAlign&gt;Middle&lt;/VerticalAlign&gt;&lt;/ColumnStyle&gt;&lt;ColumnStyle Index=&quot;8&quot;&gt;&lt;VerticalAlign&gt;Middle&lt;/VerticalAlign&gt;&lt;/ColumnStyle&gt;&lt;ColumnStyle Index=&quot;9&quot;&gt;&lt;VerticalAlign&gt;Middle&lt;/VerticalAlign&gt;&lt;/ColumnStyle&gt;&lt;ColumnStyle Index=&quot;10&quot;&gt;&lt;VerticalAlign&gt;Middle&lt;/VerticalAlign&gt;&lt;/ColumnStyle&gt;&lt;ColumnStyle Index=&quot;11&quot;&gt;&lt;VerticalAlign&gt;Middle&lt;/VerticalAlign&gt;&lt;/ColumnStyle&gt;&lt;/ColumnStyles&gt;&lt;CellStyles&gt;&lt;CellStyle Row=&quot;0&quot; Column=&quot;0&quot;&gt;&lt;v&gt;Middle&lt;/v&gt;&lt;/CellStyle&gt;&lt;CellStyle Row=&quot;0&quot; Column=&quot;1&quot;&gt;&lt;v&gt;Middle&lt;/v&gt;&lt;/CellStyle&gt;&lt;CellStyle Row=&quot;0&quot; Column=&quot;2&quot;&gt;&lt;v&gt;Middle&lt;/v&gt;&lt;/CellStyle&gt;&lt;CellStyle Row=&quot;0&quot; Column=&quot;3&quot;&gt;&lt;v&gt;Middle&lt;/v&gt;&lt;/CellStyle&gt;&lt;CellStyle Row=&quot;0&quot; Column=&quot;4&quot;&gt;&lt;v&gt;Middle&lt;/v&gt;&lt;/CellStyle&gt;&lt;CellStyle Row=&quot;0&quot; Column=&quot;5&quot;&gt;&lt;v&gt;Middle&lt;/v&gt;&lt;/CellStyle&gt;&lt;CellStyle Row=&quot;0&quot; Column=&quot;7&quot;&gt;&lt;v&gt;Middle&lt;/v&gt;&lt;/CellStyle&gt;&lt;CellStyle Row=&quot;0&quot; Column=&quot;8&quot;&gt;&lt;v&gt;Middle&lt;/v&gt;&lt;/CellStyle&gt;&lt;CellStyle Row=&quot;0&quot; Column=&quot;9&quot;&gt;&lt;v&gt;Middle&lt;/v&gt;&lt;/CellStyle&gt;&lt;CellStyle Row=&quot;0&quot; Column=&quot;10&quot;&gt;&lt;v&gt;Middle&lt;/v&gt;&lt;/CellStyle&gt;&lt;CellStyle Row=&quot;0&quot; Column=&quot;11&quot;&gt;&lt;v&gt;Middle&lt;/v&gt;&lt;/CellStyle&gt;&lt;CellStyle Row=&quot;1&quot; Column=&quot;3&quot;&gt;&lt;v&gt;Middle&lt;/v&gt;&lt;/CellStyle&gt;&lt;CellStyle Row=&quot;1&quot; Column=&quot;4&quot;&gt;&lt;v&gt;Middle&lt;/v&gt;&lt;/CellStyle&gt;&lt;CellStyle Row=&quot;1&quot; Column=&quot;5&quot;&gt;&lt;v&gt;Middle&lt;/v&gt;&lt;/CellStyle&gt;&lt;CellStyle Row=&quot;1&quot; Column=&quot;10&quot;&gt;&lt;v&gt;Middle&lt;/v&gt;&lt;/CellStyle&gt;&lt;/CellStyles&gt;&lt;ConditionalFormatCollections /&gt;&lt;/ColumnHeader&gt;&lt;DataArea class=&quot;FarPoint.Web.Spread.Model.DefaultSheetStyleModel&quot; Rows=&quot;0&quot; Columns=&quot;12&quot;&gt;&lt;AltRowCount&gt;2&lt;/AltRowCount&gt;&lt;DefaultStyle class=&quot;FarPoint.Web.Spread.NamedStyle&quot; Parent=&quot;DataAreaDefault&quot; /&gt;&lt;ColumnStyles&gt;&lt;ColumnStyle Index=&quot;0&quot;&gt;&lt;Locked&gt;True&lt;/Locked&gt;&lt;VerticalAlign&gt;Middle&lt;/VerticalAlign&gt;&lt;/ColumnStyle&gt;&lt;ColumnStyle Index=&quot;1&quot;&gt;&lt;VerticalAlign&gt;Middle&lt;/VerticalAlign&gt;&lt;/ColumnStyle&gt;&lt;ColumnStyle Index=&quot;2&quot;&gt;&lt;VerticalAlign&gt;Middle&lt;/VerticalAlign&gt;&lt;/ColumnStyle&gt;&lt;ColumnStyle Index=&quot;3&quot;&gt;&lt;VerticalAlign&gt;Middle&lt;/VerticalAlign&gt;&lt;/ColumnStyle&gt;&lt;ColumnStyle Index=&quot;4&quot;&gt;&lt;VerticalAlign&gt;Middle&lt;/VerticalAlign&gt;&lt;/ColumnStyle&gt;&lt;ColumnStyle Index=&quot;5&quot;&gt;&lt;VerticalAlign&gt;Middle&lt;/VerticalAlign&gt;&lt;/ColumnStyle&gt;&lt;ColumnStyle Index=&quot;7&quot;&gt;&lt;Margin class=&quot;FarPoint.Web.Spread.Inset&quot; Bottom=&quot;0&quot; Left=&quot;0&quot; Right=&quot;2&quot; Top=&quot;0&quot; /&gt;&lt;VerticalAlign&gt;Middle&lt;/VerticalAlign&gt;&lt;/ColumnStyle&gt;&lt;ColumnStyle Index=&quot;8&quot;&gt;&lt;VerticalAlign&gt;Middle&lt;/VerticalAlign&gt;&lt;/ColumnStyle&gt;&lt;ColumnStyle Index=&quot;9&quot;&gt;&lt;VerticalAlign&gt;Middle&lt;/VerticalAlign&gt;&lt;/ColumnStyle&gt;&lt;ColumnStyle Index=&quot;10&quot;&gt;&lt;VerticalAlign&gt;Middle&lt;/VerticalAlign&gt;&lt;/ColumnStyle&gt;&lt;ColumnStyle Index=&quot;11&quot;&gt;&lt;VerticalAlign&gt;Middle&lt;/VerticalAlign&gt;&lt;/ColumnStyle&gt;&lt;/ColumnStyles&gt;&lt;ConditionalFormatCollections /&gt;&lt;/DataArea&gt;&lt;SheetCorner class=&quot;FarPoint.Web.Spread.Model.DefaultSheetStyleModel&quot; Rows=&quot;2&quot; Columns=&quot;1&quot;&gt;&lt;AltRowCount&gt;2&lt;/AltRowCount&gt;&lt;DefaultStyle class=&quot;FarPoint.Web.Spread.NamedStyle&quot; Parent=&quot;CornerDefault&quot;&gt;&lt;Background class=&quot;FarPoint.Web.Spread.Background&quot;&gt;&lt;BackgroundImageUrl&gt;SPREADCLIENTPATH:/img/chbg.gif&lt;/BackgroundImageUrl&gt;&lt;SelectedBackgroundImageUrl&gt;SPREADCLIENTPATH:/img/chm.png&lt;/SelectedBackgroundImageUrl&gt;&lt;/Background&gt;&lt;/DefaultStyle&gt;&lt;ConditionalFormatCollections /&gt;&lt;/SheetCorner&gt;&lt;ColumnFooter class=&quot;FarPoint.Web.Spread.Model.DefaultSheetStyleModel&quot; Rows=&quot;1&quot; Columns=&quot;12&quot;&gt;&lt;AltRowCount&gt;2&lt;/AltRowCount&gt;&lt;DefaultStyle class=&quot;FarPoint.Web.Spread.NamedStyle&quot; Parent=&quot;ColumnFooterDefault&quot; /&gt;&lt;ConditionalFormatCollections /&gt;&lt;/ColumnFooter&gt;&lt;/StyleModels&gt;&lt;MessageRowStyle class=&quot;FarPoint.Web.Spread.Appearance&quot;&gt;&lt;BackColor&gt;LightYellow&lt;/BackColor&gt;&lt;ForeColor&gt;Red&lt;/ForeColor&gt;&lt;/MessageRowStyle&gt;&lt;SheetCornerStyle class=&quot;FarPoint.Web.Spread.NamedStyle&quot; Parent=&quot;CornerDefault&quot;&gt;&lt;Background class=&quot;FarPoint.Web.Spread.Background&quot;&gt;&lt;BackgroundImageUrl&gt;SPREADCLIENTPATH:/img/chbg.gif&lt;/BackgroundImageUrl&gt;&lt;SelectedBackgroundImageUrl&gt;SPREADCLIENTPATH:/img/chm.png&lt;/SelectedBackgroundImageUrl&gt;&lt;/Background&gt;&lt;/SheetCornerStyle&gt;&lt;AllowLoadOnDemand&gt;false&lt;/AllowLoadOnDemand&gt;&lt;LoadRowIncrement &gt;10&lt;/LoadRowIncrement &gt;&lt;LoadInitRowCount &gt;30&lt;/LoadInitRowCount &gt;&lt;AllowVirtualScrollPaging&gt;false&lt;/AllowVirtualScrollPaging&gt;&lt;TopRow&gt;0&lt;/TopRow&gt;&lt;PreviewRowStyle class=&quot;FarPoint.Web.Spread.PreviewRowInfo&quot; /&gt;&lt;/Presentation&gt;&lt;Settings&gt;&lt;Name&gt;Sheet1&lt;/Name&gt;&lt;Categories&gt;&lt;Appearance&gt;&lt;GridLineColor&gt;#d0d7e5&lt;/GridLineColor&gt;&lt;ColumnFooterVisible&gt;True&lt;/ColumnFooterVisible&gt;&lt;RowHeaderWidth&gt;20&lt;/RowHeaderWidth&gt;&lt;RowHeaderAutoText&gt;Blank&lt;/RowHeaderAutoText&gt;&lt;SelectionBackColor&gt;#eaecf5&lt;/SelectionBackColor&gt;&lt;SelectionBorder class=&quot;FarPoint.Web.Spread.Border&quot; /&gt;&lt;/Appearance&gt;&lt;Behavior&gt;&lt;EditTemplateColumnCount&gt;2&lt;/EditTemplateColumnCount&gt;&lt;GroupBarText&gt;グループ化するときには、ここに列名をドラッグします。&lt;/GroupBarText&gt;&lt;/Behavior&gt;&lt;Layout&gt;&lt;RowHeaderColumnCount&gt;1&lt;/RowHeaderColumnCount&gt;&lt;ColumnHeaderRowCount&gt;2&lt;/ColumnHeaderRowCount&gt;&lt;RowCount&gt;0&lt;/RowCount&gt;&lt;ColumnCount&gt;12&lt;/ColumnCount&gt;&lt;/Layout&gt;&lt;/Categories&gt;&lt;ColumnHeaderRowCount&gt;2&lt;/ColumnHeaderRowCount&gt;&lt;ColumnFooterRowCount&gt;1&lt;/ColumnFooterRowCount&gt;&lt;PrintInfo&gt;&lt;Header /&gt;&lt;Footer /&gt;&lt;ZoomFactor&gt;0&lt;/ZoomFactor&gt;&lt;FirstPageNumber&gt;1&lt;/FirstPageNumber&gt;&lt;Orientation&gt;Auto&lt;/Orientation&gt;&lt;PrintType&gt;All&lt;/PrintType&gt;&lt;PageOrder&gt;Auto&lt;/PageOrder&gt;&lt;BestFitCols&gt;False&lt;/BestFitCols&gt;&lt;BestFitRows&gt;False&lt;/BestFitRows&gt;&lt;PageStart&gt;-1&lt;/PageStart&gt;&lt;PageEnd&gt;-1&lt;/PageEnd&gt;&lt;ColStart&gt;-1&lt;/ColStart&gt;&lt;ColEnd&gt;-1&lt;/ColEnd&gt;&lt;RowStart&gt;-1&lt;/RowStart&gt;&lt;RowEnd&gt;-1&lt;/RowEnd&gt;&lt;ShowBorder&gt;True&lt;/ShowBorder&gt;&lt;ShowGrid&gt;True&lt;/ShowGrid&gt;&lt;ShowColor&gt;True&lt;/ShowColor&gt;&lt;ShowColumnHeader&gt;Inherit&lt;/ShowColumnHeader&gt;&lt;ShowRowHeader&gt;Inherit&lt;/ShowRowHeader&gt;&lt;ShowColumnFooter&gt;Inherit&lt;/ShowColumnFooter&gt;&lt;ShowColumnFooterEachPage&gt;True&lt;/ShowColumnFooterEachPage&gt;&lt;ShowTitle&gt;True&lt;/ShowTitle&gt;&lt;ShowSubtitle&gt;True&lt;/ShowSubtitle&gt;&lt;UseMax&gt;True&lt;/UseMax&gt;&lt;UseSmartPrint&gt;False&lt;/UseSmartPrint&gt;&lt;Opacity&gt;255&lt;/Opacity&gt;&lt;PrintNotes&gt;None&lt;/PrintNotes&gt;&lt;Centering&gt;None&lt;/Centering&gt;&lt;RepeatColStart&gt;-1&lt;/RepeatColStart&gt;&lt;RepeatColEnd&gt;-1&lt;/RepeatColEnd&gt;&lt;RepeatRowStart&gt;-1&lt;/RepeatRowStart&gt;&lt;RepeatRowEnd&gt;-1&lt;/RepeatRowEnd&gt;&lt;SmartPrintPagesTall&gt;1&lt;/SmartPrintPagesTall&gt;&lt;SmartPrintPagesWide&gt;1&lt;/SmartPrintPagesWide&gt;&lt;HeaderHeight&gt;-1&lt;/HeaderHeight&gt;&lt;FooterHeight&gt;-1&lt;/FooterHeight&gt;&lt;/PrintInfo&gt;&lt;TitleInfo class=&quot;FarPoint.Web.Spread.TitleInfo&quot;&gt;&lt;Style class=&quot;FarPoint.Web.Spread.StyleInfo&quot;&gt;&lt;BackColor&gt;#e7eff7&lt;/BackColor&gt;&lt;HorizontalAlign&gt;Right&lt;/HorizontalAlign&gt;&lt;/Style&gt;&lt;/TitleInfo&gt;&lt;LayoutTemplate class=&quot;FarPoint.Web.Spread.LayoutTemplate&quot;&gt;&lt;Layout&gt;&lt;ColumnCount&gt;4&lt;/ColumnCount&gt;&lt;RowCount&gt;1&lt;/RowCount&gt;&lt;/Layout&gt;&lt;Data&gt;&lt;LayoutData class=&quot;FarPoint.Web.Spread.Model.DefaultSheetDataModel&quot; rows=&quot;1&quot; columns=&quot;4&quot;&gt;&lt;AutoCalculation&gt;True&lt;/AutoCalculation&gt;&lt;AutoGenerateColumns&gt;True&lt;/AutoGenerateColumns&gt;&lt;ReferenceStyle&gt;A1&lt;/ReferenceStyle&gt;&lt;Iteration&gt;False&lt;/Iteration&gt;&lt;MaximumIterations&gt;1&lt;/MaximumIterations&gt;&lt;MaximumChange&gt;0.001&lt;/MaximumChange&gt;&lt;Cells&gt;&lt;Cell row=&quot;0&quot; column=&quot;0&quot;&gt;&lt;Data type=&quot;System.Int32&quot;&gt;0&lt;/Data&gt;&lt;/Cell&gt;&lt;Cell row=&quot;0&quot; column=&quot;1&quot;&gt;&lt;Data type=&quot;System.Int32&quot;&gt;1&lt;/Data&gt;&lt;/Cell&gt;&lt;Cell row=&quot;0&quot; column=&quot;2&quot;&gt;&lt;Data type=&quot;System.Int32&quot;&gt;2&lt;/Data&gt;&lt;/Cell&gt;&lt;Cell row=&quot;0&quot; column=&quot;3&quot;&gt;&lt;Data type=&quot;System.Int32&quot;&gt;3&lt;/Data&gt;&lt;/Cell&gt;&lt;/Cells&gt;&lt;/LayoutData&gt;&lt;/Data&gt;&lt;AxisModels&gt;&lt;LayoutColumn class=&quot;FarPoint.Web.Spread.Model.DefaultSheetAxisModel&quot; orientation=&quot;Horizontal&quot; count=&quot;4&quot;&gt;&lt;Items&gt;&lt;Item index=&quot;-1&quot;&gt;&lt;SortIndicator&gt;Ascending&lt;/SortIndicator&gt;&lt;/Item&gt;&lt;/Items&gt;&lt;/LayoutColumn&gt;&lt;LayoutRow class=&quot;FarPoint.Web.Spread.Model.DefaultSheetAxisModel&quot; orientation=&quot;Vertical&quot; count=&quot;1&quot;&gt;&lt;Items&gt;&lt;Item index=&quot;-1&quot; /&gt;&lt;/Items&gt;&lt;/LayoutRow&gt;&lt;/AxisModels&gt;&lt;/LayoutTemplate&gt;&lt;LayoutMode&gt;CellLayoutMode&lt;/LayoutMode&gt;&lt;CurrentPageIndex type=&quot;System.Int32&quot;&gt;0&lt;/CurrentPageIndex&gt;&lt;/Settings&gt;&lt;/Sheet&gt;"
                        SheetCorner-RowCount="2" RowHeaderAutoText="Blank" RowHeaderWidth="20">
                        <ColumnHeader RowCount="2" />
                        <ColumnFooter Visible="True" />
                        <RowHeader AutoText="Blank" Width="20" />
                    </FarPoint:SheetView>
                </Sheets>

<ClientEvents ActiveCellChanged="ClickDoubleRow"></ClientEvents>

                <TitleInfo BackColor="#E7EFF7" ForeColor="" HorizontalAlign="Center" VerticalAlign="NotSet"
                    Font-Size="X-Large" Font-Bold="False" Font-Italic="False" Font-Overline="False"
                    Font-Strikeout="False" Font-Underline="False">
                </TitleInfo>
            </FarPoint:FpSpread>
        </div>
    </div>
</asp:Content>
